﻿<%@ Page Title="" Language="vb" AutoEventWireup="false" MasterPageFile="~/Site.Master" CodeBehind="comment.aspx.vb" Inherits="nigerianfoodlove.comment" %>
<asp:Content ID="Content1" ContentPlaceHolderID="HeadContent" runat="server">
    <style type="text/css">

        .style1
        {
            font-family: "Segoe UI";
            color: #008000;
        }
        .style2
        {
            font-size: x-large;
            font-style: italic;
            font-weight: bold;
        }
        .style3
        {
            font-size: large;
            font-style: italic;
            font-weight: bold;
        }
        .style4
        {
            font-family: "Palatino Linotype";
            color: #008000;
            font-style: italic;
            font-weight: bold;
            font-size: xx-large;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="MainContent" runat="server">
    <span class="style1"><span class="style2">HELLOOOO</span>----
    <span class="style3">NIGERIAN FOOD LOVERS</span>------</span><span 
        class="style4">LETS AIR OUR VIEWS</span><br />
    <br />
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
        AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="SqlDataSource1" 
        Height="205px">
        <Columns>
            <asp:BoundField DataField="author" HeaderText="author" 
                SortExpression="author" />
            <asp:BoundField DataField="title" HeaderText="title" SortExpression="title" />
            <asp:BoundField DataField="comments" HeaderText="comments" 
                SortExpression="comments" />
        </Columns>
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
        ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
        SelectCommand="SELECT [author], [title], [comments], [ID], [category] FROM [comment]">
    </asp:SqlDataSource>
        <asp:TextBox ID="txtcategory" runat="server" Visible="False"></asp:TextBox>
        <br />
    <br />
    Title&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
    <asp:TextBox ID="txtitle" runat="server" Width="186px"></asp:TextBox>
    <br />
    <br />
    comment ON<asp:ListBox ID="lstcategory" runat="server" DataSourceID="SqlDataSource2" 
            DataTextField="dishcategory" DataValueField="dishcategory"></asp:ListBox>
        <asp:SqlDataSource ID="SqlDataSource2" runat="server" 
            ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
            ProviderName="<%$ ConnectionStrings:ConnectionString.ProviderName %>" 
            SelectCommand="SELECT [dishcategory] FROM [dishcategory]">
        </asp:SqlDataSource>
        <br />
    <br />
    Comment
    <br />
    <asp:TextBox ID="txtcomment" runat="server" Height="125px" 
        style="margin-left: 57px" TextMode="MultiLine" Width="279px"></asp:TextBox>
    <asp:Button ID="cmdcomment" runat="server" Text="ADD COMMENT" Width="118px" />
    <br />
</asp:Content>
